﻿CREATE TABLE [dbo].[UDS_Schedule] (
    [ID]        int          NOT NULL identity(1, 1),
    [PeriodID]  int          NOT NULL,
    [TaskID]    int          NOT NULL,
    [Username]  nvarchar(20) COLLATE Chinese_PRC_CI_AS NULL,
    [Date]      datetime     NULL,
    [IsConfirm] int          NULL,
    [Reason]    nvarchar(200) COLLATE Chinese_PRC_CI_AS NULL,

    CONSTRAINT [PK_UDS_Schedule] PRIMARY KEY CLUSTERED ([ID] asc)
);
GO
